Dashboard 01 - Creating Scatter Chart, Map, & Line and Clustered Column charts Visualizations - Part 02 14

In this step, we will continue working on the first dashboard.  We will create Scatter Chart &  Line and Clustered Column charts


Step 5 - Create Violent & Major Crime Rate Year over Year (YOY) by Year, Month & Day Line and Clustered Column chart


Visualizations

Click the Line and Clustered Column chart icon

Fields

Select the following:

A_KeyMeasures ->  .Major_CrimeRate%  - Under Visualizations, drag & drop it in the Column Values section.

A_KeyMeasures ->  .Violent_CrimeRate%  - Under Visualizations, drag & drop it in the Column Values section.

A_KeyMeasures ->  .YOY_Diff_MajorCrimeRate%  - Under Visualizations, drag & drop it in the Tooltips section.

A_KeyMeasures ->  .YOY_Diff_ShootingCrimeRate%  - Under Visualizations, drag & drop it in the Tooltips section.

A_KeyMeasures ->  .YOY_Diff_ViolentCrimeRate%  - Under Visualizations, drag & drop it in the Tooltips section.

A_KeyMeasures ->  .YOY_Major_CrimeRate%  - Under Visualizations, drag & drop it in the Line Values section.

A_KeyMeasures ->  .YOY_Violent_CrimeRate%  - Under Visualizations, drag & drop it in the Line Values section.

Raleigh_Police_Incidents_NIBRS ->  Reported_Date -> Date Hierarchy ->  Month - Under Visualizations, drag & drop it in the Shared Axis section

Raleigh_Police_Incidents_NIBRS ->  Reported_Date -> Date Hierarchy ->  Year - Under Visualizations, drag & drop it in the Shared Axis section

Raleigh_Police_Incidents_NIBRS ->  Reported_Date -> Date Hierarchy -> Quarter - Under Visualizations, drag & drop it in the Shared Axis section

Raleigh_Police_Incidents_NIBRS ->  reported_dayofwk - Under Visualizations, drag & drop it in the Shared Axis section





Visualizations


Fields tab

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the fields as follows:

.Major_CrimeRate% = Major Crime Rate

.Violent_CrimeRate% = Violent Crime Rate

.YOY_Diff_MajorCrimeRate% = YOY Diff Major Crimes

.YOY_Diff_ShootingCrimeRate%  = YOY Diff Shooting Crimes

.YOY_Diff_ViolentCrimeRate%  = YOY Diff Violent Crimes

.YOY_Major_CrimeRate%  = YOY Major Crime Rate

.YOY_Violent_CrimeRate%  = YOY Violent Crime Rate

reported_dayofwk = Reported Day of the Week




Format tab

Under Format ->  General: X Position = 700 , Y Position = 144 , Width = 700 , Height = 409

Under Format -> Legend ->  Set it to ON , Position = Top Center , Color = 000000 , Font Family = Segoe UI , Text Size = 12 pt , Style = Markers Only

Under Format -> X Axis -> Type = Continuous , Scale Type = Linear ->  Color = 000000 , Text Size = 10 pt , Font Family = Segoe UI , Title = OFF , Style = Show Title OFF , Gridlines = OFF

Under Format -> Y Axis -> Position = Left , Scale Type = Linear ->  Start = 0.1 ,  Color = 000000 , Text Size = 11 pt , Font Family = Segoe UI , Title = OFF , Style = Show Title OFF , Gridlines = ON , Color = 000000 , Stroke Width = 2 , Line Style = Dotted , Show Secondary = ON , Y-Axis (Line) Position = Right , Scale Type = Linear , Color = 025214 , Text Size = 12 pt , Font Family = Segoe UI , Title = OFF

Under Format ->  Data Colors -> YOY Major Crime Rate = 51C6FF , YOY Violent Crime Rate = 6B007B , Major Crime Rate = 078AFF , Violent Crime Rate = CF6B7D

Under Format ->  Data Labels ->  Set it to ON , Color = 000000 , Value Decimal Places = 0 , Text Size = 13 pt , Font Family = Segoe UI , Label Density = 50% , Show Background = Off ,

Customize Series  = ON ,

(Select Major Crime Rate -> Show = ON , Color = 000000 , Value Decimal Values = 0 , Text Size = 13 , Font Family = Segoe UI , Label Density = 50% , Show Background = OFF) ,

(Select Violent Crime Rate -> Show = ON , Color = 000000 , Value Decimal Values = 0 , Text Size = 13 , Font Family = Segoe UI , Label Density = 50% , Show Background = OFF)

(Select YOY Major Crime Rate -> Show = ON , Color = 026514 , Value Decimal Values = 0 , Text Size = 13 , Font Family = Segoe UI , Label Density = 50% , Show Background = OFF)

(Select Major Crime Rate -> Show = ON , Color = 026514 , Value Decimal Values = 0 , Text Size = 13 , Font Family = Segoe UI , Label Density = 50% , Show Background = OFF)

Under Format ->  Shapes -> Shade Area = ON , Stroke Width = 2 , Join Type = Round , Line Style = Solid , Show Marker = ON , Marker Shape = . (dot) , Marker Size = 5

Under Format -> Title ->  Set it to ON , Title Text = Violent & Major Crime Rate Year over Year (YOY) by Year, Month & Day , Font Color = 094780 , Background Color = E6E6E6 , Alignment = Center , Text Size = 17 pt , Font Family = DIN (Default)

Under Format ->  Background ->  Set it to ON , Color = FFF

Under Format ->  Border ->  Set it to ON , Color = 666666





Filters

None



Visualization Listing

For Line and Clustered Column chart, have the visualizations listed in the following order:




Sorting

In the Data tab -> click on  Raleigh_Police_Incidents_NIBRS ->  reported_dayofwk , click on Column Tools tab ->  Sort by Column and select Weekday_Number




Sort  by Reported Day of the week:





Step 6 - Create Violent & Major Crime Rate Year over Year (YOY) by Time of Day  & Hour Line and Clustered Column chart

To get you started, copy and paste chart used in Step 5 (Violent & Major Crime Rate Year over Year (YOY) by Year, Month & Day Line and Clustered Column chart). 

Click on the chart, press Ctrl+C to copy and Ctrl+V to paste it.  Set the new chart as follows:


Visualizations

Click the Line and Clustered Column chart icon

Fields

Select the following:

A_KeyMeasures ->  .Major_CrimeRate%  - Under Visualizations, drag & drop it in the Column Values section.

A_KeyMeasures ->  .Violent_CrimeRate%  - Under Visualizations, drag & drop it in the Column Values section.

A_KeyMeasures ->  .YOY_Diff_MajorCrimeRate%  - Under Visualizations, drag & drop it in the Tooltips section.

A_KeyMeasures ->  .YOY_Diff_ShootingCrimeRate%  - Under Visualizations, drag & drop it in the Tooltips section.

A_KeyMeasures ->  .YOY_Diff_ViolentCrimeRate%  - Under Visualizations, drag & drop it in the Tooltips section.

A_KeyMeasures ->  .YOY_Major_CrimeRate%  - Under Visualizations, drag & drop it in the Line Values section.

A_KeyMeasures ->  .YOY_Violent_CrimeRate%  - Under Visualizations, drag & drop it in the Line Values section.

Raleigh_Police_Incidents_NIBRS ->  reported_hour - Under Visualizations, drag & drop it in the Shared Axis section.

Raleigh_Police_Incidents_NIBRS ->  Time_By_Hour - Under Visualizations, drag & drop it in the Tooltips section.

Raleigh_Police_Incidents_NIBRS ->  Time_Of_Day - Under Visualizations, drag & drop it in the Shared Axis section (Remove the extra fields).



Visualizations


Fields tab

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the fields as follows:

.Major_CrimeRate% = Major Crime Rate

.Violent_CrimeRate% = Violent Crime Rate

.YOY_Diff_MajorCrimeRate% = YOY Diff Major Crimes

.YOY_Diff_ShootingCrimeRate%  = YOY Diff Shooting Crimes

.YOY_Diff_ViolentCrimeRate%  = YOY Diff Violent Crimes

.YOY_Major_CrimeRate%  = YOY Major Crime Rate

.YOY_Violent_CrimeRate%  = YOY Violent Crime Rate

reported_hour = Reported Hour

Time_By_hour = Time By Hour

Time_Of_Day = Time of Day




Format tab

Under Format ->  General: X Position = 700 , Y Position = 533 , Width = 700 , Height = 420

Under Format -> Legend ->  Set it to ON , Position = Top Center , Color = 000000 , Font Family = Segoe UI , Text Size = 12 pt , Style = Markers Only

Under Format -> X Axis -> Color = 000000 , Text Size = 11 pt , Font Family = Segoe UI , Title = OFF

Under Format -> Y Axis -> Position = Left , Scale Type = Linear ->  Color = 000000 , Text Size = 11 pt , Font Family = Segoe UI , Title = OFF , Style = Show Title OFF , Gridlines = ON , Color = 000000 , Stroke Width = 2 , Line Style = Dotted , Show Secondary = ON , Y-Axis (Line) Position = Right , Scale Type = Linear , Color = 025214 , Text Size = 12 pt , Font Family = Segoe UI , Title = OFF

Under Format ->  Data Colors -> YOY Major Crime Rate = 51C6FF , YOY Violent Crime Rate = 6B007B , Major Crime Rate = 078AFF , Violent Crime Rate = CF6B7D

Under Format ->  Data Labels ->  Set it to ON , Color = 000000 , Value Decimal Places = 0 , Text Size = 12 pt , Font Family = Segoe UI , Label Density = 30% , Show Background = Off ,

Customize Series  = ON ,

(Select Major Crime Rate -> Show = ON , Color = 000000 , Value Decimal Values = 0 , Text Size = 13 , Font Family = Segoe UI , Label Density = 50% , Show Background = ON, Transparency = 30%) ,

(Select Violent Crime Rate -> Show = ON , Color = 000000 , Value Decimal Values = 0 , Text Size = 13 , Font Family = Segoe UI , Label Density = 50% , Show Background = ON, Transparency = 30%)

(Select YOY Major Crime Rate -> Show = ON , Color = 026514 , Value Decimal Values = 0 , Text Size = 13 , Font Family = Segoe UI , Label Density = 50% , Show Background = ON, Transparency = 30%)

(Select YOY Violent Crime Rate -> Show = ON , Color = 026514 , Value Decimal Values = 0 , Text Size = 13 , Font Family = Segoe UI , Label Density = 50% , Show Background = ON , Transparency = 30%)

Under Format ->  Shapes -> Shade Area = ON , Stroke Width = 2 , Join Type = Round , Line Style = Solid , Show Marker = ON , Marker Shape = . (dot) , Marker Size = 5

Under Format -> Title ->  Set it to ON , Title Text = Violent & Major Crime Rate YOY by Time of Day & Hour , Font Color = 094780 , Background Color = E6E6E6 , Alignment = Center , Text Size = 18 pt , Font Family = DIN (Default)

Under Format ->  Background ->  Set it to ON , Color = FFF

Under Format ->  Border ->  Set it to ON , Color = 666666




Filters

None



Visualization Listing

For Line and Clustered Column chart, have the visualizations listed in the following order:






Sorting

In the Data tab -> click on  Raleigh_Police_Incidents_NIBRS ->  Time_By_Hour , click on Column Tools tab ->  Sort by Column and select Time By Hour


When finished, save project.






For assistance in creating a Line and Clustered Column Chart in Power BI:


Tips on how to create a Line and Clustered Column Chart in Power BI